/****** Object:  StoredProcedure dbo.fn_asi_GetLastFirst  ******/
create function dbo.fn_asi_GetLastFirst(@LastName varchar(30),@FirstName varchar(20))
returns varchar(30)
  as
begin
      declare @NewLastFirst varchar(30)
     if @FirstName is null
         set @FirstName = ''
     if @LastName is null
         set @LastName = ''
     if @FirstName<>'' and @LastName<>''
         set @NewLastFirst = RTRIM(LTRIM(@LastName)) + ', ' + LTRIM(RTRIM(@FirstName))
     else
         set @NewLastFirst = LTRIM(RTRIM(@LastName)) + ' ' + LTRIM(RTRIM(@FirstName))
     -- get the new last first value
     set @NewLastFirst = REPLACE(LTRIM(RTRIM(@NewLastFirst)),'''','')
     set @NewLastFirst = dbo.fn_asi_convert_foreign_string(@NewLastFirst)
     set @NewLastFirst = UPPER(@NewLastFirst)
     return @NewLastFirst
          
  end

GO
GRANT EXECUTE ON  [dbo].[fn_asi_GetLastFirst] TO [IMIS]
GO